package com.funmi.lizip.mapper;

import com.funmi.lizip.entity.EcPostDisasterAssessment;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
* @author wangdc
* @description 针对表 灾后评估【ec_post_disaster_assessment】的数据库操作Mapper
* @createDate 2022-11-03 10:33:07
* @Entity com.funmi.lizip.entity.EcPostDisasterAssessment
*/
public interface EcPostDisasterAssessmentMapper extends BaseMapper<EcPostDisasterAssessment> {

    @Select("select id, title, fire_time, address, area, main_tree, house, personnel, animal, important_facilities, basic_geographic_information, basic_environmental_information,forest_resources_information,alarm_no,content,create_at from ec_post_disaster_assessment where id = #{id}")
    EcPostDisasterAssessment getById(int id);


    @Update("update ec_post_disaster_assessment  set is_delete = 1 where id = #{id}")
    boolean delete(Long id);
}




